<?php
include("../libreria/config.php");
include("../libreria/db.php");
$total=0;
?>
<html>
	<head>	
		<title>Materias</title>
		<link type="text/css" href="../jquery/css/redmond/jquery-ui-1.8.13.custom.css" rel="stylesheet" />
		<link rel="stylesheet" type="text/css" href="../jquery/css/redmond/estilostv.css" media="all"/>		
		<script type="text/javascript" src="../jquery/js/jquery-1.5.1.min.js"></script>
		<script type="text/javascript" src="../jquery/js/jquery-ui-1.8.13.custom.min.js"></script>
		<script type="text/javascript" src="../jquery.lightbox_me.js"></script>
	</head>
<body>
<center>
<div id="users-contain" class="ui-widget">
	<h1>Notas:</h1>
	<table id="users" class="ui-widget ui-widget-content">
		<thead>
			<tr class="ui-widget-header ">
				<th>id_nota</th>
				<th>id_profesor</th>
				<th>matricula</th>
				<th>Asistencia</th>
				<th>Participacion</th>
				<th>Ex_parcial</th>
                <th>Ex_Final</th>
                <th>Total</th>
                 <th>Excel</th>
                  <th>PDF</th>
                
			</tr>
		</thead>
		<tbody>
			<?php
				$sql = "select * from tbl_nota";
				$result = dbQuery($sql);
				
				while($row = dbFetchAssoc($result))
				{
					echo "<tr>
							<td>".$row['id_nota']."</td>
							<td>".$row['id_profesor']."</td>
							<td>".$row['matricula']."</td>
							<td>".$row['asistencia']."</td>
							<td>".$row['participacion']."</td>
							<td>".$row['ex_parcial']."</td>
							<td>".$row['ex_final']."</td>
							<td>".$row['total']."</td>
							<td><a href='genera_excel.php?id=".$row['id_nota']." target='_blank'>Excel</a> </td>
						<tr>						
						";			
				}
mysql_free_result($result);				
			?>
		</tbody>
	</table>
</div>
</center>
</body>